INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES
((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V RMS A', 0, 1, 0, 0, NULL, 1, 0, 1);INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V RMS B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V RMS C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I RMS A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I RMS B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I RMS C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
(SELECT ID FROM Phase WHERE Name LIKE 'NG'),
'I RMS N', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS N' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IN_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V THD A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V THD B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V THD C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I THD A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I THD B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I THD C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
(SELECT ID FROM Phase WHERE Name LIKE 'NG'),
'I THD N', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD N' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIN_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Flicker Pst A', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst A' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VA');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Flicker Pst B', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst B' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VB');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Flicker Pst C', 0, 1, 0, 0, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst C' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VC');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 2' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 3' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 4' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 5' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 6' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 7' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 8' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 9' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 10' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 11' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 12' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 13' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 14' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 15' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 16' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 17' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'V Harmonic A 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'V Harmonic B 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'V Harmonic C 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 2' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 3' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 4' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 5' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 6' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 7' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 8' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 9' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 10' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 11' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 12' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 13' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 14' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 15' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 16' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 17' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
'I Harmonic A 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IA_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
'I Harmonic B 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IB_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 2', 0, 1, 0, 2, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 3', 0, 1, 0, 3, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 4', 0, 1, 0, 4, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 5', 0, 1, 0, 5, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 6', 0, 1, 0, 6, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 7', 0, 1, 0, 7, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 8', 0, 1, 0, 8, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 9', 0, 1, 0, 9, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 10', 0, 1, 0, 10, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 11', 0, 1, 0, 11, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 12', 0, 1, 0, 12, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 13', 0, 1, 0, 13, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 14', 0, 1, 0, 14, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 15', 0, 1, 0, 15, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 16', 0, 1, 0, 16, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 17', 0, 1, 0, 17, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 18', 0, 1, 0, 18, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 19', 0, 1, 0, 19, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 20', 0, 1, 0, 20, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 21', 0, 1, 0, 21, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 22', 0, 1, 0, 22, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 23', 0, 1, 0, 23, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 24', 0, 1, 0, 24, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 25', 0, 1, 0, 25, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 26', 0, 1, 0, 26, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 27', 0, 1, 0, 27, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 28', 0, 1, 0, 28, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 29', 0, 1, 0, 29, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 30', 0, 1, 0, 30, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 31', 0, 1, 0, 31, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 32', 0, 1, 0, 32, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IC_10MIN');
INSERT INTO Channel
(MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
VALUES((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
'I Harmonic C 33', 0, 1, 0, 33, NULL, 1, 0, 1);
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IC_10MIN');